Numeric parameters allow users to build parameters based on static numeric values. Once a numeric parameter has been built and saved, it can then be added to a formula or list, which is then added to a query in Discover.
Numeric parameters may be configured as either global, or model parameters. Global parameters are a type of numeric parameter which can be used across different data models, data bases, and servers. Model parameters are built using a given server, database, and data model, and may be either text (based on given hierarchy members) or numeric.
To learn how to create business logic using numeric parameters, see Parameterizing Formulas (Custom Members), Parameterizing Lists, and Date Range Parameters.
Numeric Parameter Types
There are two types on numeric parameters: discrete list and continuous. From the Members step, choose the required type.
Discrete List
Choose Discrete List to create a list of discrete values. You can enter either numeric or text values; enter text values to build a global discrete list text parameter. Each given value will be labeled according to the corresponding caption assigned to it.
Using the plus sign, add the required number of parameter elements. In the Value column, write the relevant values, and in the Caption column, enter the caption for each value. The resulting parameter will be a list of discrete numeric or text values, from which specific values may be selected.
A discrete list numeric parameter may be visualized as a drop down, list box, button, or text box slicer.
Continuous
Select Continuous to create a continuous slider, measuring from the given minimum value up to and including the given maximum value. The step represents the interval between values in the slider.
Continuous list parameters can be visualized as either a slider or a text box slicer.
